EMT Practice Test

1. Question Content...

---

Question1: True or False: It is possible to load data into Snowflake without creating a named File Format object.

Question2: Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:

Question3: True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

Question4: For a multi-cluster Warehouse, the number of credits billed is calculated on:
Select one.

Question5: What is the default File Format used in the COPY command if one is not specified?

Question6: When should you consider disabling auto-suspend for a Virtual Warehouse? (Choose two.)

Question7: True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

Question8: True or false: it is best practice to define a clustering key on every table.

Question9: Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
Select one:

Question10: Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy?
Select one.

Question11: The Query History in the Snowflake Web Interface (UI) is kept for approximately:

Question12: Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)

Question13: Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Question14: True or False: You can query the files in an External Stage directly without having to load the data into a table.

Question15: The fail-safe retention period is how many days?

Question16: Which of the following statements about data sharing are true?
choose 2 answers

Question17: Which of the following are options when creating a virtual Warehouse?
Choose 2 answers

Question18: A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)

Question19: When loading data into Snowflake, the COPY command supports:
Choose 2 answers

Question20: Which statement best describes '' clustering''?

Question21: True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

Question22: Which of the following objects is not covered by Time Travel?

Question23: When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers

Question24: True or False: You can define multiple columns within a clustering key on a table.

Question25: How would you execute a series of SQL statements using Task?

Question26: True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

Question27: True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

Question28: True or False: It is possible to load data into Snowflake without creating a named File Format object.

Question29: True or False: A Virtual Warehouse can be resized while suspended.

Question30: What is the minimum Snowflake edition that provides data sharing?

Question31: A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

Question32: What is the recommended Snowflake data type to store semi-structured data like JSON?

Question33: The PUT command: (Choose two.)

Question34: True or False: Snowflake charges a premium for storing semi-structured data.

Question35: True or False: Snowpipe via REST API can only reference External Stages as source.

Question36: True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

Question37: True or False: It is possible to unload structured data to semi-structured formats such as JSON and Parquet.

Question38: In which layer of its architecture does Snowflake store its metadata statistics?
Select one.

Question39: What is the minimum duration charged when starting a virtual warehouse?

Question40: True or False the longer the data retention period, the higher the resulting storage costs.

Question41: What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.

Question42: What are the three things customers want most from their enterprise data warehouse solution?
Choose 3 answers

Question43: In which layer of its architecture does Snowflake store its metadata statistics?

Question44: True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

Question45: Which of the following items does the Cloud services Layer manage?
Choose 4 answers

Question46: Which of the following statements is true of zero-copy cloning?

Question47: Which object allows you to limit the number of credits consumed within a Snowflake account?
Select one.

Question48: When creating a user it is advisable sable to:
Choose 2 answers

Question49: Which statement best describes Snowflake tables?

Question50: Which of the following are options when creating a Virtual Warehouse?

Question51: What is the minimum Snowflake edition that provides data sharing?

Question52: Select the different types of Internal Stages: (Choose three.)

Question53: Which of the following is true of Snowpipe via REST API?
Choose 2 answers

Question54: A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers

Question55: True or False: All Snowflake table types include fail-safe storage.

Question56: Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)

Question57: When can a Virtual Warehouse start running queries?

Question58: Which of the following are common use cases for zero-copy cloning?
Choose 3 answers

Question59: True or False: When you create a custom role, it is a practice to immediately grant that role to ACCOUNTADMIN.

Question60: Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answers

Question61: A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

Question62: The number of queries that a Virtual Warehouse can concurrently process is determined by:
Choose 2 answers

Question63: What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

Question64: Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

Question65: True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

Question66: True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

Question67: True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).

Question68: Fail-safe is unavailable on which table types?

Question69: Which are true of Snowflake roles?

Question70: Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:

Question71: True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

Question72: Which of the following commands are not blocking operations?
Choose 2 answers

Question73: Select the three types of tables that exist within Snowflake.
Choose 3 answers

Question74: Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)

Question75: True or False: Snowflake charges additional fees to Data providers for each share they create.

Question76: What are the three layers that make up Snowflake's architecture?
Choose 3 answer

Question77: Which of the following statements are true of Snowflake releases: (Choose two.)

Question78: Account-level storage usage can be monitored via:

Question79: How many shares can be consumed by single Data Consumer?